UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQY9sP7FVoMHk3W525V73LDbsF18gx9B9ESgW412WSI='
WHERE
key_id = 'a41d56b091d02ff5bd95dff45c499700e8e5c2ce69984f8ade5305b751203ef4'
AND (
token = 'nQY9sP7FVoMHk3W525V73LDbsF18gx9B9ESgW412WSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)