UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YiF7oIwnmU+s4hnLe1V734hFyDRl5I8Mv1t7GkrMZxw='
WHERE
key_id = 'e5b7b49fe0ed85f17b57ff111c7b260af3eace1ea5d80590eed601ae0b207da4'
AND (
token = 'YiF7oIwnmU+s4hnLe1V734hFyDRl5I8Mv1t7GkrMZxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)