UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CZIFA0wuS2URX1eiHJ+WQqxpsL2EnPyTyofXL6/6XjE='
WHERE
key_id = 'a48f4e562288a11a0528476d673856ca1725bccc8a44221f9c9e7e9ebfca14b2'
AND (
token = 'CZIFA0wuS2URX1eiHJ+WQqxpsL2EnPyTyofXL6/6XjE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)