UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PIcB16NMAUw1GntAehPVq7DgHG10sobjkf/rYl1etiY='
WHERE
key_id = '9fbb5c33ee02c439bbf178cc6ae496c102070a06533bf62c9e3592a845c5ab1f'
AND (
token = 'PIcB16NMAUw1GntAehPVq7DgHG10sobjkf/rYl1etiY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)