UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qoJ2NdZIPQeVF5CguZllaH3cNyMrFQ9TpFN6nGNHdfQ='
WHERE
key_id = 'f378f24c07bd342ec7fc77e79d5c9c2a53166ff9f8755655180daed77cefa005'
AND (
token = 'qoJ2NdZIPQeVF5CguZllaH3cNyMrFQ9TpFN6nGNHdfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)