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