UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oiacM9z597xcW0SFJxfV15s6kDncbr7X5ZKscClj0LY='
WHERE
key_id = '5c19b2ddfd51cac84350e31a3c992bef48973bae428c392820ee315071949813'
AND (
token = 'oiacM9z597xcW0SFJxfV15s6kDncbr7X5ZKscClj0LY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)