UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bw1k5BRhtRMjAFmaXu0SrY46IP+MUF1Owsw216O0wrA='
WHERE
key_id = '00de08775a6bbdd335678dd786d5fec29ea159ae510cbe89c6a132784bbb2125'
AND (
token = 'Bw1k5BRhtRMjAFmaXu0SrY46IP+MUF1Owsw216O0wrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)