UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9nR98lvuI673NNrrwiQg5Ic8aMqgyzwVuSVMJnfyc+o='
WHERE
key_id = 'a505daad10a85889517f17c70e8538850f049af68accf90fca652a5066c29b34'
AND (
token = '9nR98lvuI673NNrrwiQg5Ic8aMqgyzwVuSVMJnfyc+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)