UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tgvBdBsIHch21fALyQPoaHZC/s5SRrAkaHtmeVnLD18='
WHERE
key_id = 'a87b9d28125f5bea7a395a033335e46e8f61c121e521abe75a74a9deb697b76c'
AND (
token = 'tgvBdBsIHch21fALyQPoaHZC/s5SRrAkaHtmeVnLD18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)