UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SmYGGRCm2+EgSoLGZvlHYea3GV+BzMCFEiBWk7bW5Eg='
WHERE
key_id = 'bad181c296dff84da9fe3db90077e1edae9773400a773dee999aa96c6f2a8ff2'
AND (
token = 'SmYGGRCm2+EgSoLGZvlHYea3GV+BzMCFEiBWk7bW5Eg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)