UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V9jr+afuOEIVtWw5vkRyNzIpUjdFwloZ6c0OGXg7GK4='
WHERE
key_id = '1e9bf8a44ae51deded422dd403a010f403a3adb526a0467c127e96169216c7d7'
AND (
token = 'V9jr+afuOEIVtWw5vkRyNzIpUjdFwloZ6c0OGXg7GK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)