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