UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cs74g45r7tJO3DT0IdtoOc/Ct2XrdVnu6DTEj8Hb2tU='
WHERE
key_id = '44b9e368c05f5a94b81598f331581ba75294fc6372e1273886ab3a5503594ce1'
AND (
token = 'cs74g45r7tJO3DT0IdtoOc/Ct2XrdVnu6DTEj8Hb2tU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)