UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bsgka1p3FtlropHU7JAGuCZuVqAma8LhEYynQc7S4+8='
WHERE
key_id = '7da8a95a951b558d56b88dff6b6d77883c439c938a6dde274c0ce04c8aabcde5'
AND (
token = 'bsgka1p3FtlropHU7JAGuCZuVqAma8LhEYynQc7S4+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)