UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MzW1QThRMf5rzwsGAa4T8cZlV30SVW9iWSBohq5Kf90='
WHERE
key_id = '78174fffdc83dfce157b960a92cb9292f621071ab464b2cdb3ca917219823356'
AND (
token = 'MzW1QThRMf5rzwsGAa4T8cZlV30SVW9iWSBohq5Kf90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)