UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tLiaP4PzBkL9Pcs7V4gD5OF8RxjvjRCXZ1el02aPMLw='
WHERE
key_id = '15eb047ef9fe87f4c81a1ea9e1fdcf0aaf87a4e9207bc221da6544b6a9078daf'
AND (
token = 'tLiaP4PzBkL9Pcs7V4gD5OF8RxjvjRCXZ1el02aPMLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)