UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eDMYrCvxKG8fUJCibZ/mFjTfZoBqDCkH95F57b+ptWo='
WHERE
key_id = 'ad3bd02c5ee78ed758989c917741bf7bc6fce4f91d1fd2f7667eea0fb8309eb2'
AND (
token = 'eDMYrCvxKG8fUJCibZ/mFjTfZoBqDCkH95F57b+ptWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)