UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XOVqJddC7TVBvcu3Sa342TYPjUbGi1VLBiRkW1Z5Nn8='
WHERE
key_id = '0ff98308e45b55ae1fca3edb606bc5b22699cc6c466355561bc2d425b0b51cf2'
AND (
token = 'XOVqJddC7TVBvcu3Sa342TYPjUbGi1VLBiRkW1Z5Nn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)