UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8xKP4flofD591/pyH5dGNV8LZyKUakUXnwbMU3NLpP0='
WHERE
key_id = '82da6090912e301238982b49582f83437b48015b27e9970929c11cfbf6e4ab8c'
AND (
token = '8xKP4flofD591/pyH5dGNV8LZyKUakUXnwbMU3NLpP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)