UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YNonqaFkBgI9lAcIJpSXkahk/HqPq+h3bu1lkyIrxsA='
WHERE
key_id = 'e723715ca5513efbfcd3166ae46de8989e2a30923b87972b53f5ca8b643c3b17'
AND (
token = 'YNonqaFkBgI9lAcIJpSXkahk/HqPq+h3bu1lkyIrxsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)