UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZLh9KZTeDXIdEkG+vGJYiOiqEsdNQVl8sc1x+ysfnjI='
WHERE
key_id = '02ab162327ce72ab9bf7c11079b6ca442af3a11b6f24ac6227a32e75ac02c96f'
AND (
token = 'ZLh9KZTeDXIdEkG+vGJYiOiqEsdNQVl8sc1x+ysfnjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)