UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cXptYgT+2zK6+2rku5JlwLZ69Yy3wHBBdEn6Bmn4u5c='
WHERE
key_id = '3a5c9d48f884f015b594e22f95a51878f74d21b2e99d2cde893437217a44cfb8'
AND (
token = 'cXptYgT+2zK6+2rku5JlwLZ69Yy3wHBBdEn6Bmn4u5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)