UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gMuD0wENtOcbw5bVR8qTKTNvccGVDE7mFGQlZzBm2sU='
WHERE
key_id = '5de045999a0d59315860e5fe6f2e031fb20c610656147d0de12e1f0ee2a87306'
AND (
token = 'gMuD0wENtOcbw5bVR8qTKTNvccGVDE7mFGQlZzBm2sU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)