UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yjy+lXz84tx7GydY6J9qCxdI1EaE6jRyrbpv0qBnH0g='
WHERE
key_id = '2147f8aa11d97b4fc10ec74a6c93b4346986f0cb4d5658718a5f1803c86c92db'
AND (
token = 'yjy+lXz84tx7GydY6J9qCxdI1EaE6jRyrbpv0qBnH0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)