UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RhZbaHFefkDYWoL1dzO9pbhILxto3Tj6sCiNdEVxyHg='
WHERE
key_id = '92888f9701810a8feda8fea0f3753efed7cf268bee3036bbfe79c10d35a097ec'
AND (
token = 'RhZbaHFefkDYWoL1dzO9pbhILxto3Tj6sCiNdEVxyHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)